/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_pricing_info.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_PRICING_INFO
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_pricing_info.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_PRICING_INFO::CTable_PPM_PRICING_INFO( )
 :NPCRecordSet( )
{
  setTableName( "PPM_PRICING_INFO" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  PRICING_PLAN_ID.setField( "PRICING_PLAN_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_PLAN_ID );
  PRICING_DETAIL_ID.setField( "PRICING_DETAIL_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_DETAIL_ID );
  NAME.setField( "NAME", DATA_CHAR, 50, 0 );
  makeTableItem( NAME );
  CHANNEL_ID.setField( "CHANNEL_ID", DATA_CHAR, 9, 0 );
  makeTableItem( CHANNEL_ID );
  PRICING_EXPRESS_ID.setField( "PRICING_EXPRESS_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_EXPRESS_ID );
  EXPRESS_ID.setField( "EXPRESS_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( EXPRESS_ID );
  ACCT_ITEM_TYPE_ID.setField( "ACCT_ITEM_TYPE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( ACCT_ITEM_TYPE_ID );
  PRI_PRICING_DETAIL_ID.setField( "PRI_PRICING_DETAIL_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRI_PRICING_DETAIL_ID );
  EXP_DATE.setField( "EXP_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EXP_DATE );
  EFF_DATE.setField( "EFF_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EFF_DATE );
  PRICE.setField( "PRICE", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICE );
}


CTable_PPM_PRICING_INFO::CTable_PPM_PRICING_INFO( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_PRICING_INFO" );
  prepareTable();
  prepareQuery();
 
  ID.setField( "ID", DATA_DOUBLE, 22, 1 );
  makeTableItem( ID );
  makeKeyItem( ID ); 
  PRICING_PLAN_ID.setField( "PRICING_PLAN_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_PLAN_ID );
  PRICING_DETAIL_ID.setField( "PRICING_DETAIL_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_DETAIL_ID );
  NAME.setField( "NAME", DATA_CHAR, 50, 0 );
  makeTableItem( NAME );
  CHANNEL_ID.setField( "CHANNEL_ID", DATA_CHAR, 9, 0 );
  makeTableItem( CHANNEL_ID );
  PRICING_EXPRESS_ID.setField( "PRICING_EXPRESS_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICING_EXPRESS_ID );
  EXPRESS_ID.setField( "EXPRESS_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( EXPRESS_ID );
  ACCT_ITEM_TYPE_ID.setField( "ACCT_ITEM_TYPE_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( ACCT_ITEM_TYPE_ID );
  PRI_PRICING_DETAIL_ID.setField( "PRI_PRICING_DETAIL_ID", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRI_PRICING_DETAIL_ID );
  EXP_DATE.setField( "EXP_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EXP_DATE );
  EFF_DATE.setField( "EFF_DATE", DATA_DATETIME, 7, 0 );
  makeTableItem( EFF_DATE );
  PRICE.setField( "PRICE", DATA_DOUBLE, 22, 0 );
  makeTableItem( PRICE );
}

CTable_PPM_PRICING_INFO::~CTable_PPM_PRICING_INFO( )
{
    close();
}

